The String Left node is used to include only a substring consisting of a given number of characters from a string column, moving from left to right. This is useful if the string contains a prefix that is private or not relevant for end-users for instance.
Take the Left String
Start by connecting the String Left node to the Select node of the relevant table. Go to the Properties panel to define the substring:
- Select Column: choose the relevant column from the drop down.
- Characters to Take: enter the number of characters to be included in the substring, from left to right.
- Column Output: decide whether or not to keep the original column.
- New Column Name: name the new column.
Example: Take the Left Substring
In this example, the first 11 characters in the string are taken:
Related information
Common Properties
There are a number of fields that are present in the Properties panel when you have any of the preceding nodes selected on the canvas. These fields include Result Properties, Column Selection, Set Variable Values, and Metadata.
- Click here for more details about the Common Properties